select @docCircUser1:=DcUserId from DcUser where Login='DocCircUser1';

-- Add institutions: Intsitution1, Institution2

insert into institution (DcUser, Name, Phone1, Phone2, Address1, Address2, Email1, Email2, WebSite, Note)
	Values (@docCircUser1, 'Institution1', '1111-1', '1111-2', 'FirstAddressOfInst1', 'SecondAddressOfInst1', 
	'inst11@test.org', 'inst12@test.org', 'inst1.test.org', 'the best institution');
select @institution1:=last_insert_id();

insert into institution (DcUser, Name, Phone1, Phone2, Address1, Address2, Email1, Email2, WebSite, Note)
	Values (@docCircUser1, 'Institution2', '2222-1', '2222-2', 'FirstAddressOfInst2', 'SecondAddressOfInst2', 
	'inst21@test.org', 'inst22@test.org', 'inst2.test.org', 'a better institution');
select @institution2:=last_insert_id();

